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 itemid 1235494566667896614 and match in Replace field column 2 i.e. order-ID Table2 Recordorder-ID12345671 549xyzabc 2 666mhldef 36614ghijakmnoqwetyuewsghj4789pqrstu 5 899fghklj Expected Result only ids which matching with table 2 append columns itemid 1234567123549xyzabc 456666mhldef 7896614ghijakmnoqwetyuewsghj

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.

Hi @KamalChoudhary Your workflow should be something like this. Is this not working Hope this helps : ) join dynamic (1).yxmd

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

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

Dynamic Processing

Join

Data Investigation

Accepted answers

All comments

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 : )

join dynamic.yxmd

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

Qiu

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703