Read mapping and fill a table with the desired fields.

Question

Hello everyone!

I would appreciate some help with an especific problem I'm having.

The task is for alteryx to read an excel document like:

FieldCorrespondingDateDate_1NameName_2AmountAmount_1Details-

and 'select' the rows from a table like:

Date_1Date_2Name_1Name_2Amount_1Amount_2Details_1Details_24/4/20245/4/2024AAAABBBB5030DDDDEEE4/4/20245/4/2024AAAABBBB5030BBBEEE4/4/20245/4/2024AAAABBBB5068BBBEEE5/5/20246/4/2024BBBBAAAA6068BBBCCC5/5/20246/4/2024BBBBAAAA6068XXXCCC

The output of this flux would have to be:

DateNameAmountDetails4/4/2024BBBB50 4/4/2024BBBB50 4/4/2024BBBB50 5/5/2024AAAA60 5/5/2024AAAA60

A detail is that this flux can't have an input from a user, I would like to build this into a macro.

I thank you all in advance!

Have a great day.

DataNath · Accepted Answer

Hey @thirodrigues here's an approach that'll work for what you're after. In short the workflow:

1) Looks for the 'corresponding' fields and renames them to the target name

2) Cross-Tabs the 'lookup' of fields you want to keep, ready to use this as a template schema

3) Unions the two streams, only keeping like-for-like named columns i.e. those that you want

4) Does a second Union with the 'model schema' in order to add in any additional fields that you want but don't appear in the main data

Hope this helps!