How can i read sub-columns in main column?

in excel there is some sub- columns in main column , i can read main column ,but how to read sub column

1 Like

Hey @Narayana_Acharyulu

By default it should have read it.

If not set the starting range of Read Range activity to A2

Thanks
#nK

In A1 is name (Main Column) , A2 FirstName & B2 Second Name .And i want read separately, even it is not Merage

1 Like

Yes @Narayana_Acharyulu

Try setting the read range starting range prop as A2

Thanks
#nK

formQuestion

1 Like

how can i read{ Loc(Location(current)),Loc(Location(New))}

1 Like

can you try this? As i said in this post Im not changing any column names in the original excel excel… only the datatable VARIABLE so that you can read and reference it. The excel and its headers stays the same

With the new datatable variable you can easily read the current and new location using Loc-Location-Current and Loc-Location-New.
image

iam using Reframe work ,how can i get it in get transaction data

Read Table.xaml (31.6 KB)

in initialization state, call this read_table.xaml , pass in excel path and sheet name and assign out_transactionData output to the REFramework dt_TransactionData variable, thats all

thankyou @jack.chan ,let me try it once

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.