I have a problem to append dynamic columns using Find and Replace tool

[KamalChoudhary]

I'm using find and replace to append columns in Table1, Not sure how to append dynamic columns 

Problem = column are dynamic not fixed changed every time based on input ( using {Append fields to records} of find and replace tool)

Find column 2 i.e. ID

Table1

item	id
123	549
456	666
789	6614

and match  in Replace field  column 2 i.e. order-ID

Table2

Record	order-ID	1	2	3	4	5	6	7
1	549	xyz	abc
2	666	mhl	def
3	6614	ghi	jak	mno	qwe	tyu	ews	ghj
4	789	pqr	stu
5	899	fgh	klj

Expected Result only ids which matching with table 2 append columns 

item	id	1	2	3	4	5	6	7
123	549	xyz	abc
456	666	mhl	def
789	6614	ghi	jak	mno	qwe	tyu	ews	ghj

[atcodedog05]

Hi @KamalChoudhary 

You can use join tool and check the unknown column option (refer to highlighted) this accommodates all the newly occurring columns.

Hope this helps : )

[KamalChoudhary]

Hi @atcodedog05 ,

Thank you so much for your help,

Assume in table1 data which is not matching still get populated in the final result , we have tried using union to append row which is not matching.in join from table 1.

Is it viable or you can suggest some better workaround.

Any suggestion to get rid of (Warning: Union (7): The field "" is not present in all inputs).for columns which are not present in inputs, (refer to highlighted) 

updated

  Table1

item	id
123	549
456	666
789	6614
798	777

[KamalChoudhary]

Hi @atcodedog05 

Thanks you very much for helping, 

Assume I want to keep the values of table 1 which are not matching, while joining the data,  we have have used union.

it is viable to use or any other workaround 

Updated Table1

item	id
123	549
456	666
789	6614
798	777

Expected Result

tem	id	1	2	3	4	5	6	7
123	549	xyz	abc
456	666	mhl	def
789	6614	ghi	jak	mno	qwe	tyu	ews	ghj
798	777

[KamalChoudhary]

Hi @atcodedog05 

Thanks you very much for helping, 

Assume I want to keep the values of table 1 which are not matching, while joining the data,  we have have used union.

it is viable to use or any other workaround 

[atcodedog05]

Hi @KamalChoudhary 

Yes use union tool after join.

Hope this helps : )

[Qiu]

@KamalChoudhary 
Can you define what you mean by Dynamic? Column Name? Number of Columns?

[KamalChoudhary]

Hi @atcodedog05 ,

After using union toot we have noticed some data is missing, it there any specific reason ?

we are joining  left output  data with joined data 

[atcodedog05]

Hi @KamalChoudhary 

Your workflow should be something like this. Is this not working

Hope this helps : )

[Akash__on]

here the values in table 1 is less than table 2 and they are all matched so nothing is in the L output of the Join tool as shown by @atcodedog05 .

But suppose if anything is not matched it will come in the L and R output of the join tool which can again be used by union tool. as shown above. 

• for dynamic inputs we leave one column blank. 

I hope you got the solution.