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

AnalyticsApp2.yxmd

Book1.xlsx

Developer

Gallery

Developer Tools

Custom Tools

Common Use Cases

Best Practices

Apps

Batch Macro

Interface Tools

Accepted answers

Felipe_Ribeir0

Hi @stevelogue1980

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

AnalyticsApp2.yxzp

Felipe_Ribeir0

Hi @stevelogue1980

Try to use the record id tool

All comments

binu_acs

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

binu_acs

@stevelogue1980 One way doing this

AnalyticApp_1103.yxzp

stevelogue1980

@binu_acs

Appreciated for quick turnaround.

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

Felipe_Ribeir0

Hi @stevelogue1980

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

AnalyticsApp2.yxzp

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

Hi @stevelogue1980

Try to use the record id tool

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703