Question & Answer > View Question

[HELP] How to Manipulate Data After Import Tool And Then Save It to Datalist?

Confluence User - 12 Sep, 2022

Need help here guys!

How to manipulate the data right after Import Tool using and then save the manipulated data into the Datalist?

Here's the data example:

I want the data to be saved into something like this:

Before i was using Multi Tools then Database Update Tools with sql query like this, it works tho but it just doesn't feel right. I want the "LIKE" query could look into a column table that contain the keyword for each member for the data manipulation. How could i achieve that?

Any little help would be very appreciated. Thank you guys!

forms;datalists;sql;import-tool;importing;process;workflow;beanshell;database;spreadsheet;fileupload;filters

2

Confluence User •

12 Sep, 2022 •

confluenceUser •

•

confluenceUser •

Consider using the iterator process tool

Iterator Process Tool - Marketplace Knowledge Base - Joget | COMMUNITY

after import tool, use iterator to db query a list of all the available members and perform a db update tool for each member in the list.

Confluence User •

19 Sep, 2022 •

confluenceUser •

•

confluenceUser •

Thanks for the response sir, but i want to get the list of the available members from a column table data. How can i achieve that?

1

CSV | Excel | XML | PDF

Your answer

Print

[HELP] How to Manipulate Data After Import Tool And Then Save It to Datalist?

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-ce2d175e-74a1-42a0-b870-cb47156fc335{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-deda6d9f-ba32-4bef-aa2c-4743bc066926{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer