SOLVED

How to store CSV data of Data loding (file) in Javascript variable?

uz2020
Level 2
Level 2

Hello, I'm Super Beginner.

 

How to store CSV data of Data loding (file) in Javascript variable?

Or can read the CSV file directly with JavaScript?

 

Thank you.

1 Accepted Solution
ParthaSarathy
Correct answer by
Level 5
Level 5

Hi @uz2020 ,

Lets say your Csv file contains 2 columns 'name' and 'email'. And internal name of your data loading (file) activity as 'fileImport'.

Next to your data loading activity, place a javaScript activity and try the below coding,

 

var query = xtk.queryDef.create(
<queryDef schema="temp:fileImport" operation="select">
<select>
<node expr="name"/>
<node expr="email"/>
</select>
</queryDef>
);
var record = query.ExecuteQuery();
for each (var variable in record) {
instance.vars.name = variable.name;
instance.vars.email= variable.email;
logInfo("Name is : "+instance.vars.name);
logInfo("Email is : "+instance.vars.email);
}
 
Regards,
ParthaSarathy S

View solution in original post

2 Replies
ParthaSarathy
Correct answer by
Level 5
Level 5

Hi @uz2020 ,

Lets say your Csv file contains 2 columns 'name' and 'email'. And internal name of your data loading (file) activity as 'fileImport'.

Next to your data loading activity, place a javaScript activity and try the below coding,

 

var query = xtk.queryDef.create(
<queryDef schema="temp:fileImport" operation="select">
<select>
<node expr="name"/>
<node expr="email"/>
</select>
</queryDef>
);
var record = query.ExecuteQuery();
for each (var variable in record) {
instance.vars.name = variable.name;
instance.vars.email= variable.email;
logInfo("Name is : "+instance.vars.name);
logInfo("Email is : "+instance.vars.email);
}
 
Regards,
ParthaSarathy S

View solution in original post