Column Name supplied as Input but getting recognized as text

[gangwar59]

Hi all,

I am stuck with one flow so will be very helpful if any solution is suggested.

Scenario -

1. Input File:-

I am supplying the column Name as input ex. in below Header is the name of column and Name1 is the text value..

Header

Name1

2. Dynamic Input tool-

 Connecting to my Database i am fetching 2 columns

Name1	Name2
0	TestInput

When i use Apend Tool, I get the value as below 

Name1	Name2	Header
0	TestInput	Name1

My issue is, I want the actual value '0' instead of Name1 under Header as that is the value of Name1.

Since this is macro i am trying to create therefore simply adding formula tool to make Name1 value equal to DynamicInputTool output value will not help here as this need to extended for different tables and columns will vary.

Is there any way i can make altreyx understand that Name1 under Header is actually name of the another column and not text field ?

FYI.. Adding brackets [ ] is again not working here :(

[ArtApa]

Hi @gangwar59 - Here is a possible solution. Not sure if I fully understood your requirement though.