Merge Input file with Dynamic Field.

[dhirajs2024]

I am trying to consolidate 2 input date with dynamic fields , attached is the sample file.

[binu_acs]

@dhirajs2024 join multiple should work on your use-case

[dhirajs2024]

My data has blank record id , please find the example's with more data. Also the input can be 3 .

[dhirajs2024]

Does anyone have a solution?

[nagakavyasri]

@dhirajs2024 

[dhirajs2024]

Thanks, 

if [Row-1:Name]=[Name] then null() else [Name] endif

but the above expression will only work for max 2 record when i add more data it give me below result
1 A Texas 8889 AAAA 20 Park 555
1 [Null] [Null] [Null] BBBB 25 Park2 666
1 A Texas 8889 AAAA 20 Park 555

i used unique but again the records get scattered

[lwolfie]

Not sure if you figured this out, but instead of using Name I would use Record.  if [Row-1:Record]=[Record] then null() else [Name] endif

[dreldrel]

You can use a batch macro to combine the columns among multiple files