I need to check E214 and E212 columns from text file

Help Studio
, ,
1

I need to check E214 and E212 columns from text file

My data table:
Huawei_IR21_DB.xlsx (9.5 KB)

My text file:
sample11.txt (1.7 KB)

My workflow:

image
image1148Ă—668 25.8 KB

Thanks
Shaik

1 Like
2

Hi @shaik.muktharvalli1

In the If activity change the condition as below,

- Condition -> Final_Text.Contains(CurrentRow("E214").toString) andalso Final_Text.Contains(CurrentRow("E212").toString)

Hope it helps!!

3

@shaik.muktharvalli1

check the reference

4

Why my current row not printed in output

image
image1750Ă—840 47.3 KB

5

May I know What data do you want to print in Write line… @shaik.muktharvalli1

Could you be more specific…

6

Column E214 of row

Thanks
Shaik

7

Okay @shaik.muktharvalli1

Then give like this, CurrentRow(“E214”).toString

This will print the Current row value in the write line.

Hope you understand!!

8

Hi @shaik.muktharvalli1 ,

Output:-

image

Xaml File:-
check text fro dt forum.zip (10.4 KB)

If this works for you, please mark it as a solution, so others can refer the same… :slight_smile:

Thanks

9

Your out put wrong @Jayesh_678

All E214 rows are present in Text file please check

image
image709Ă—404 7.19 KB

please

Thanks
Shaik

1 Like
10

Hi @shaik.muktharvalli1

Your screenshot & attached sample text file in this thread is different.

Thanks

11

Is it working for you… @shaik.muktharvalli1

If you have any further queries let me know

12

I found my Quary

Read text file …read limited text only

How I can read whole text

sample11.txt (300.5 KB)

13

I have checked with Read Text file activity it was working fine for me… @shaik.muktharvalli1

Are you getting any error while you are reading file.

14

can you send workflow please @mkankatala

1 Like
15

Hi @shaik.muktharvalli1

Output:-
image

Xaml File:-
check text from dt forum.zip (40.7 KB)

Thanks.