Analytics App update from an excel file based on Actions

[stevelogue1980]

User should be able to Pick up values for Gender (Female) & State(New Jersey& New York) and based on the input, it should write to target (here Browse) followed by few other tools for transformations

Expected Output:

Please find the workflow& excel input attached

[binuacs]

@stevelogue1980 your excel input file is missing. Can you upload it?

[binuacs]

@stevelogue1980 One way doing this

[stevelogue1980]

@binuacs 

Appreciated for quick turnaround.

However, STATE should be multiple selection as I asked earlier like NJ & NY  or ALL possibly?

[Felipe_Ribeir0 · Accepted solution]

Hi @stevelogue1980 

One way of allowing the selection of 1 gender (Male or female) and multiple states (New Jersey & New York for example)

 

[stevelogue1980]

How to add Row ID for each Row for the same workflow?

Tried to use 'Generate Rows' but, i have to define incremental rows (ex:RowCount <= 10), but when you dont know how many rows and need distinct ID for each row?

[Felipe_Ribeir0 · Accepted solution]

Hi @stevelogue1980 

Try to use the record id tool