Inserting data into template

[Surajnair]

Hi All,

I need help in inserting data into template.

1. Template is created from alteryx

2. im using DB connection to extract the data of user who's having ERP page module access

3. i verify my sql data by checking if any values from Name and Value columns are matching with my template header.

if its matching then i want to insert data into template by name , username , last login date and if module and submodule names are matching with template headers then it should be true or false

Im attaching below files.

Pls help on the same.

[MeganBowers · Accepted solution]

Hi @Surajnair,

I believe the attached solution is close to what you're looking for (with 1 = TRUE, blank = FALSE). I combined your two workflows and then I used the temp.xlsx file to create a mapping table, so I knew which fields went under which subheaders. This solution will need a little cleanup with field names (one thing I did was change all names to title case). But it should put you on the right track!

 

[Surajnair]

Thank You @MeganBowers,

This really helped.