Created 2 data tables and used join data table activity but o/p differs

Help Studio
, ,
1

created 2 data tables DT and DT_1 and used join data table activity but in o/p getting only the headers but not the rows,thanks for any help!!!

1
11494×987 154 KB

2
3
31420×906 130 KB

2

output screen shot

op
op1272×525 83.6 KB

3

@Sai_Kumar_111

for the second dt are you using read range

before writing to excel can you check the data whether the Dt_joined is have data or not

use log message and pass Dt_joined.Rows.count

4

Hi Shiva

im not getting any data in DT_joined got it through message activity but why???

5

@Sai_Kumar_111

can you try by this way once in Join datatable by passing column Index

image
image786×475 15.1 KB

6

still getting the same!!!

7

@Sai_Kumar_111

can you share the image entire flow of activities which you have used

8

A
A1897×1027 226 KB

B
B1915×973 232 KB

C
C1914×1024 236 KB

9

in such case check, if maybe some spaces at the end of values will block the Join Check

Can be done eg.

when this is the issue we would cleanse up / trimming the values before using for the Join

1 Like
10

@Sai_Kumar_111

can you check any duplicate variables with the same name is present or not?

also check whether the data for DT_1 and DT is present or not

got it i think for read range you need change the range i think, you have passed “A1”

11

you are right but still getting same after i changed the range not getting where’s wrong!!!

12

@Sai_Kumar_111

take a new workflow and try with the activities again

use build datatable and read range and join datatable

before excecuting join datatable check whether the data is coming or not from Build Datatable and read range activity

dt.rows.count
DT_1.rows.count

check it once

1 Like
13

@Sai_Kumar_111

  1. Please check the datatypes of the columns that you read using read range…may be in the datatable it is coming as string type column
  2. To verify change the datatype in build datatable activity also to string from int32 and check

Hope this helps

Cheers

1 Like
14

this may be true peter but after i have created a new work flow and created the data tables in the studio itself i havent got any error,thank you.

15

I have taken the new work flow and tried and also created the data tables in the studio itself and havent got any errors,thank you.

1 Like
16

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