How can i read sub-columns in main column?

Help Studio
, ,
1

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

1 Like
2

Hey @Narayana_Acharyulu

By default it should have read it.

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

Thanks
#nK

3

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

1 Like
4

Yes @Narayana_Acharyulu

Try setting the read range starting range prop as A2

Thanks
#nK

5

formQuestion

1 Like
6

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

1 Like
7

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

8

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

9

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

image
image848Ă—758 32.3 KB

10

thankyou @jack.chan ,let me try it once

1 Like
11

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