Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 1
uz2020
Level 1

Likes

0 likes

Total Posts

32 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
uz2020
Level 1

Likes

0 likes

Total Posts

32 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
uz2020
Level 1

18-01-2021

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.

View Entire Topic

Avatar

Avatar
Give Back
Level 4
ParthaSarathy
Level 4

Likes

34 likes

Total Posts

59 posts

Correct Reply

26 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Give Back
Level 4
ParthaSarathy
Level 4

Likes

34 likes

Total Posts

59 posts

Correct Reply

26 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile
ParthaSarathy
Level 4

19-01-2021

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