JOIN DATA BY USER SELECTION FIELDS

[Terrymax]

HI All

i am trying to : 

1 . build an APP to allow user import their own data 

2. allow user to select the key field for join data

3. by using the key field , join to antoher master list

4. get the result. 

As below pictures show, the user selected fields are unable to pass to the join tools. 

Anyone can help? or share some kind of such APP to me ? 

Thanks very much!

[atcodedog05]

Hi @Terrymax 

Can you please provide the associated input files of the worfklow.

[Terrymax]

Please find two files: 

By using the  LE ID to join the master list 

[atcodedog05]

Hi @Terrymax 

You can setup workflow like below for your usecase.

Workflow:

Hope this helps : )

[Terrymax]

Thanks so much~!

But it only works by using the Field name = LE_ID.  If i changed the the field name of the input file , follwoing errors pop up. 

Can use some funciton like dynamic rename or replace a specific string? thanks! 

[MatthewBr]

Something similar. 

Please remember to mark as complete if your answer has been met! Nice job community!

[atcodedog05 · Accepted solution]

Hi @Terrymax 

Sadly column name options are not dynamic in a single App.

You can achieve using chained app. 

1st app: Saves user file data and column name data into files.

2nd app: In this app, load the column name options from the file which was outputted in previous app and proceed forward.

Output:

Hope this helps : )

[Terrymax]

@atcodedog05  Appreciated your help!

Another error pop up when i try to test other files which is the "Field type" are not string( following sceen shot refers), could you please help to fix the input data types in string so the filed can be joined by master fields as same data type. 

BTW, could you please share some resouces to me for learning  the chianed app? thanks! 

[MatthewBr · Accepted solution]

1. Here is a link to a bunch of video content on the community:

Video Training Index - Alteryx Community

2. My guess is you will need a select in your workflow to convert the "ID" fields in question to be in the same format (string)

[Terrymax]

hi @atcodedog05 

I still encounter some issues:

1. Do you know why the "list values" is disabled from my end?

2. How can i change the data type as string for all for user selected fileds?