Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

JOIN DATA BY USER SELECTION FIELDS

Terrymax
7 - Meteor

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!

 

 

Terrymax_0-1631535362468.png

 

10 REPLIES 10
atcodedog05
22 - Nova
22 - Nova

Hi @Terrymax 

 

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

Terrymax
7 - Meteor

Please find two files: 

 

By using the  LE ID to join the master list 

atcodedog05
22 - Nova
22 - Nova

Hi @Terrymax 

 

You can setup workflow like below for your usecase.

 

Workflow:

atcodedog05_0-1631536624723.png

 

Hope this helps : )

 

Terrymax
7 - Meteor

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! 

 

Terrymax_0-1631537921669.png

 

 

MatthewBr
Alteryx Alumni (Retired)

Something similar. 


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

atcodedog05
22 - Nova
22 - Nova

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.

atcodedog05_0-1631540285463.png

 

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

atcodedog05_2-1631540365652.png

 

Output:

atcodedog05_3-1631540480781.png

 

Hope this helps : )

Terrymax
7 - Meteor

@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! 

 

Terrymax_0-1631583826320.png

Terrymax_1-1631583850044.png

 

MatthewBr
Alteryx Alumni (Retired)

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
7 - Meteor

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? 

 

Terrymax_0-1631864485583.png

 

Labels