Hi there

I am writing a bot that consumes a CSV file and I have the data into a DataTable. Its all there and it looks great.

I am trying to figure out how to loop over that DataTable as for each row I need to update columns that are empty. I have looked through the DataTable package and the Control package but do not really see a way to do this. 

I assume that I have to use a for or a for each just wondering if there a proper pattern for this?

Thanks

------------------------------
Troy DesBarres
------------------------------

Dear Troy,

You are right, for this we will need to loop through the DataTable with either For or For Each loop.

What I usually do:
1. use a For loop with an iterator variable to loop through the DataTable 
2. use Map Table Row to map the column to corresponding variables
3. to check if a variable is empty/null value, you can consider the Empty or Null Text Variable command

I have some screenshots below for reference.

------------------------------
JENNY KHUC
------------------------------

Original Message:
Sent: Tue January 12, 2021 07:41 AM
From: Troy DesBarres
Subject: DataTable - CSV Load

Hi there

I am writing a bot that consumes a CSV file and I have the data into a DataTable. Its all there and it looks great.

I am trying to figure out how to loop over that DataTable as for each row I need to update columns that are empty. I have looked through the DataTable package and the Control package but do not really see a way to do this. 

I assume that I have to use a for or a for each just wondering if there a proper pattern for this?

Thanks

------------------------------
Troy DesBarres
------------------------------

Hi Jenny this is great stuff exactly what I needed 

Thanks
Troy

------------------------------
Troy DesBarres
------------------------------

Original Message:
Sent: Tue January 12, 2021 09:10 PM
From: JENNY KHUC
Subject: DataTable - CSV Load

Dear Troy,

You are right, for this we will need to loop through the DataTable with either For or For Each loop.

What I usually do:
1. use a For loop with an iterator variable to loop through the DataTable 
2. use Map Table Row to map the column to corresponding variables
3. to check if a variable is empty/null value, you can consider the Empty or Null Text Variable command

I have some screenshots below for reference.

------------------------------
JENNY KHUC

Original Message:
Sent: Tue January 12, 2021 07:41 AM
From: Troy DesBarres
Subject: DataTable - CSV Load

Hi there

I am writing a bot that consumes a CSV file and I have the data into a DataTable. Its all there and it looks great.

I am trying to figure out how to loop over that DataTable as for each row I need to update columns that are empty. I have looked through the DataTable package and the Control package but do not really see a way to do this. 

I assume that I have to use a for or a for each just wondering if there a proper pattern for this?

Thanks

------------------------------
Troy DesBarres
------------------------------

Hi Jenny,

That is fine if we get minimal columns from an excel and we should know what column names we're getting.

but, what if there are more number of columns and the columns we're getting dynamically, we don't know what columns we're getting so we can't map. please help on this.

I've trying to achieve this but no luck.

------------------------------
raju vanga
------------------------------

Original Message:
Sent: Tue January 12, 2021 09:10 PM
From: JENNY KHUC
Subject: DataTable - CSV Load

Dear Troy,

You are right, for this we will need to loop through the DataTable with either For or For Each loop.

What I usually do:
1. use a For loop with an iterator variable to loop through the DataTable 
2. use Map Table Row to map the column to corresponding variables
3. to check if a variable is empty/null value, you can consider the Empty or Null Text Variable command

I have some screenshots below for reference.

------------------------------
JENNY KHUC

Original Message:
Sent: Tue January 12, 2021 07:41 AM
From: Troy DesBarres
Subject: DataTable - CSV Load

Hi there

I am writing a bot that consumes a CSV file and I have the data into a DataTable. Its all there and it looks great.

I am trying to figure out how to loop over that DataTable as for each row I need to update columns that are empty. I have looked through the DataTable package and the Control package but do not really see a way to do this. 

I assume that I have to use a for or a for each just wondering if there a proper pattern for this?

Thanks

------------------------------
Troy DesBarres
------------------------------