Standardizing excel file according to two criteria in Uipath

Help Activities
, , ,
1

I want to save the value at the intersection of b2 and a3. For example, the intersection of the soup product group (a3) ​​at date x (b2) is lentil soup. I want to be able to print lentil soup as a variable. I will create a 3-column excel with the name lentil soup on x date.
Can you help?

Forum Engagement Daily Reports
2

@Ozlem_Eldes

Welcome to the community

Not sure how the data looks

But as per scenario you can use lookup datatable if single table

Join if two tables

Cheers

3

@Ozlem_Eldes welcome to community

You can declare one variable and use for each data row activity to go through each row
Assign value from this column using string manipulation technique.

If you can share more data or screen shot of data

4
Monday
PRODUCT GROUP 04.12.2023
SOUPS Mercimek Çorba
UNSALT-FREE SOUP Toyga Çorba (Tuzsuz)
ALA CARTE MENU (4 CAPITALS)
— —
ALA CARTE MENU ALA CARTE MENU
SOUPS Mercimek Çorba
UNSALT-FREE SOUP Toyga Çorba (Tuzsuz)

Thank you. as the output is realized but I want it to be like below

04.12.2023 SOUPS Mercimek Çorba
04.12.2023 UNSALT-FREE SOUP Toyga Çorba (Tuzsuz)
5

Monday
PRODUCT GROUP 04.12.2023

SOUPS Mercimek Çorba
UNSALT-FREE SOUP Toyga Çorba (Tuzsuz)
ALA CARTE MENU (4 CAPITALS)
— —
ALA CARTE MENU ALA CARTE MENU
SOUPS Mercimek Çorba
UNSALT-FREE SOUP Toyga Çorba (Tuzsuz)

Thank you. as the output is realized but I want it to be like below

04.12.2023 SOUPS Mercimek Çorba
04.12.2023 UNSALT-FREE SOUP Toyga Çorba (Tuzsuz)
6

@Ozlem_Eldes

Can you please tell the input is coming in excel?

if so can it have multipel data once after other? is it possible to attach a sample instead of screenshot

cheers