Forum Discussion

Raj123's avatar
Raj123
Frequent Visitor
2 years ago

Create new table\Column to add filtered Data

Hi,

I have requirement to filter value based on condition and add it new column on existing table (If possible) or create new table . 

I want to filter value for arrivaldate, arrivaltime, deaprturedate, departuretime where status is "in" and add them to new column or into new table, same with status "out".

I have added sample table and output required table.

Any assistance will be helpful.

Thank you in advance.

Sample Table

 

IDLastNameFirstNameArrivalDateArrivalTimeDeparturedateDepartureTimeStatus
1First1Last118/03/202421:2018/03/202416:40out
1First1Last119/03/20248:3519/03/20241:30out
1First1Last129/03/20245:1528/03/202422:55in
1First1Last129/03/202418:1029/03/20247:45in
1First2Last218/03/202421:2018/03/202416:40out
1First2Last219/03/20248:3519/03/20241:30out
1First2Last229/03/20245:1528/03/202422:55in
1First2Last229/03/202418:1029/03/20247:45in

 

Output Required

 

IDLastNameFirstNameOUT_ArrivalDateOUT_ArrivalTimeOUT_DeparturedateOUT_DepartureTimeStatusIN_ArrivalDateIN_ArrivalTimeIN_DeparturedateIN_DepartureTimeStatus
1First1Last118/03/202421:2018/03/202416:40out29/03/20245:1528/03/202422:55in
1First1Last119/03/20248:3519/03/20241:30out29/03/202418:1029/03/20247:45in
1First2Last218/03/202421:2018/03/202416:40out29/03/20245:1528/03/202422:55in
1First2Last219/03/20248:3519/03/20241:30out29/03/202418:1029/03/20247:45in

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

     

    I have requirement to filter value based on condition and add it new column on existing table (If possible) or create new table .

     

    neither of this is possible. You cannot create (meaningful) columns or tables from measures or user choices (filters).