Combining two set of data with requirement

[SH_94]

Hi community,

I would like to ask how do combine two set of data with the following requirement.

If there is no value in original input data , then it will present as zero in the output data as per screenshot below

Many thanks for th support.

[ArtApa]

Hi @SH_94 - Based on the provided description ID must also be zero. However, the desired output looks like it just took ID by position. I've built a solution to match a sample output:

[Yoshiro_Fujimori]

I am not exactly sure what you mean by "If there is no value in original input data , then it will present as zero".

From the output table, I guess you want to keep all the records from Input2 table and

to fill in the values on Input1 table from top to down for each customer.

If that is the case,

1. Set sequence number for each customer for both input tables

2. Join the tables with Customer and Sequence Number.

3. Union Join and Right output

4. Replace Null values with 0

Workflow

Output

I do not know how you want to do with the ID. So I left it as Null.

[SH_94]

Hi @ArtApa ,

Many thanks for the prompt response.

May i know if there is way to make the workflow more dynamic if i have the data set below :

Many thanks

[ArtApa · Accepted solution]

Hi @SH_94 - I updated the workflow:

[SH_94]

Hi @ArtApa ,

Many thanks for the help and you really a life saver as i have been thinking of how to fix it for few days and decided to ask for help at the end.

Thanks a lot for the sharing and i just know it can be solved in this fantantic way.