Changing Field Names in the App

Question

Hi everyone,

Thank you for your time,

The input file's column names are not standard. Is it possible to map the correct field names to the ones in the file using an interface tool? Below is an example.

Acc NoAmnt451510-545.7128100545.7451510-545.71281001457.88423100-1457.88

How the field names should be:

Account NumberFunctional Amount451510-545.7128100545.7451510-545.71281001457.88423100-1457.88

for this, I have a reference file

Field NameAccount NumberFunctional Amount

so I want to let users decide and map the correct field names from the reference file.

I found a similar solution here

But instead of letting the user type, I would like them to use, for eg, a drop-down tool to map the correct field names.

Thanks in advance for your help

apathetichell · Answer

Yeah - you need to use chained apps.

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

Adarsh_R3 · Answer

Yes, @apathetichell exactly like u mentioned the field names in the drop-down is not changing dynamically. Even when I select different files the fields in the dropdown tool is stays the same.

Not sure why this is happening.

Here is a similar solution that I found, but the field names in the dropdown tool are static.

I've also attached the sample workflow, thanks for helping!

New Workflow1.yxwz

apathetichell · Answer

Do you mean that you can't get the app to change the dropdown field names on the fly - or you can't get it to run manually when you add new data to that macro? You'll need to run to refresh - unless you do a chained app. That adds a step to make it a fairly complicated project.

The bulk for me would be  a batch macro where each column I require is matched against a full list of columns in the datasource and then selected and renamed and everything is then unioned together... The macro you posted takes a different approach but I can't really judge it from a photo.