多地址输入字段数据有序传输处理的技术实现问询

Got it, let's work through this problem step by step. You need to take your 5 address input fields, filter out the empty ones, and map the non-empty values to sequential output lines—regardless of which original input line they came from.

First, let's confirm the setup: you've already got flag variables (let's name them addr1_flag, addr2_flag, ..., addr5_flag) where 1 means the corresponding input field has valid data, and 0 means it's empty.

Implementation Logic #

We'll build each output line by sequentially checking the input fields, skipping empty ones, and assigning the first valid value we find for each output position. Here's how to write the expressions for each output field (works in tools like Informatica, SQL, or any language supporting conditional CASE/IIF statements):

1. Output Line 1 (First non-empty input)

This grabs the very first valid address line from your input sequence:

O_ADDR_LINE_1 = 
CASE 
    WHEN addr1_flag = 1 THEN I_ADDR_LINE_1_TX
    WHEN addr2_flag = 1 THEN I_ADDR_LINE_2_TX
    WHEN addr3_flag = 1 THEN I_ADDR_LINE_3_TX
    WHEN addr4_flag = 1 THEN I_ADDR_LINE_4_TX
    WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
    ELSE ''
END

2. Output Line 2 (Second non-empty input)

This skips the input field used for Output Line 1, then grabs the next valid one:

O_ADDR_LINE_2 = 
CASE 
    -- If Line 1 was used, check Lines 2-5 next
    WHEN addr1_flag = 1 THEN 
        CASE 
            WHEN addr2_flag = 1 THEN I_ADDR_LINE_2_TX
            WHEN addr3_flag = 1 THEN I_ADDR_LINE_3_TX
            WHEN addr4_flag = 1 THEN I_ADDR_LINE_4_TX
            WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
            ELSE ''
        END
    -- If Line 1 was empty but Line 2 was used, check Lines 3-5
    WHEN addr2_flag = 1 THEN 
        CASE 
            WHEN addr3_flag = 1 THEN I_ADDR_LINE_3_TX
            WHEN addr4_flag = 1 THEN I_ADDR_LINE_4_TX
            WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
            ELSE ''
        END
    -- If Lines 1-2 were empty, check Lines 3-5
    WHEN addr3_flag = 1 THEN 
        CASE 
            WHEN addr4_flag = 1 THEN I_ADDR_LINE_4_TX
            WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
            ELSE ''
        END
    -- If Lines 1-3 were empty, check Lines 4-5
    WHEN addr4_flag = 1 THEN 
        CASE 
            WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
            ELSE ''
        END
    ELSE ''
END

3. Output Line 3 (Third non-empty input)

Follow the same pattern—skip the first two valid input fields, then grab the next one:

O_ADDR_LINE_3 = 
CASE 
    WHEN addr1_flag = 1 AND addr2_flag = 1 THEN 
        CASE 
            WHEN addr3_flag = 1 THEN I_ADDR_LINE_3_TX
            WHEN addr4_flag = 1 THEN I_ADDR_LINE_4_TX
            WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
            ELSE ''
        END
    WHEN addr1_flag = 1 AND addr3_flag = 1 THEN 
        CASE 
            WHEN addr4_flag = 1 THEN I_ADDR_LINE_4_TX
            WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
            ELSE ''
        END
    WHEN addr2_flag = 1 AND addr3_flag = 1 THEN 
        CASE 
            WHEN addr4_flag = 1 THEN I_ADDR_LINE_4_TX
            WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
            ELSE ''
        END
    WHEN addr1_flag = 1 THEN 
        CASE 
            WHEN addr4_flag = 1 THEN I_ADDR_LINE_4_TX
            WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
            ELSE ''
        END
    WHEN addr2_flag = 1 THEN 
        CASE 
            WHEN addr4_flag = 1 THEN I_ADDR_LINE_4_TX
            WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
            ELSE ''
        END
    WHEN addr3_flag = 1 THEN 
        CASE 
            WHEN addr4_flag = 1 THEN I_ADDR_LINE_4_TX
            WHEN addr5_flag = 1 THEN I_ADDR_LINE_5_TX
            ELSE ''
        END
    ELSE ''
END

4. Output Lines 4 & 5

Repeat the pattern for these—each time skipping the previously used valid input fields and grabbing the next available non-empty value. The logic mirrors what we did for Lines 2 and 3, just extending the checks further down the input sequence.

Example Validation #

Let's test your sample scenarios to confirm this works:

• Scenario 1: Only I_ADDR_LINE_2 and I_ADDR_LINE_4 have data (addr2_flag=1, addr4_flag=1, others 0)
  • O_ADDR_LINE_1 = I_ADDR_LINE_2_TX
  • O_ADDR_LINE_2 = I_ADDR_LINE_4_TX
  • O_ADDR_LINE_3 to O_ADDR_LINE_5 = empty strings
• Scenario 2: I_ADDR_LINE_1, I_ADDR_LINE_3, I_ADDR_LINE_5 have data (addr1_flag=1, addr3_flag=1, addr5_flag=1)
  • O_ADDR_LINE_1 = I_ADDR_LINE_1_TX
  • O_ADDR_LINE_2 = I_ADDR_LINE_3_TX
  • O_ADDR_LINE_3 = I_ADDR_LINE_5_TX
  • O_ADDR_LINE_4 to O_ADDR_LINE_5 = empty strings

Simplification Tip (If Your Tool Supports Arrays) #

If you're working in a language that supports arrays or collections (like Python, JavaScript, or some ETL tools), you can simplify this drastically:

1. Collect all non-empty input fields into an array:

   non_empty_addrs = [
       val for val in [I_ADDR_LINE_1_TX, I_ADDR_LINE_2_TX, I_ADDR_LINE_3_TX, I_ADDR_LINE_4_TX, I_ADDR_LINE_5_TX]
       if val.strip() != ''
   ]
   

2. Map the array to your output lines (filling empty strings for unused positions):

   O_ADDR_LINE_1 = non_empty_addrs[0] if len(non_empty_addrs) >=1 else ''
   O_ADDR_LINE_2 = non_empty_addrs[1] if len(non_empty_addrs) >=2 else ''
   O_ADDR_LINE_3 = non_empty_addrs[2] if len(non_empty_addrs) >=3 else ''
   O_ADDR_LINE_4 = non_empty_addrs[3] if len(non_empty_addrs) >=4 else ''
   O_ADDR_LINE_5 = non_empty_addrs[4] if len(non_empty_addrs) >=5 else ''
   

内容的提问来源于stack exchange，提问作者Abhinav mittal