SOLVED
NO Cartesian join required
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Kuldeepmathur
8 - Asteroid
‎10-07-2022
02:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to create a movement dataset where I am trying to record the movement of Ids from Last month to this month
My input file looks like this :
rpt_dt_key | ID | Type | Type 2 | Division | Pillar | Cost Center | Company |
5/31/2022 | 21 | Transfer Out | Exits | X Division | |||
5/31/2022 | 21 | Transfer IN | Adds | Y Division | |||
5/31/2022 | 21 | Transfer Out | Exits | A | |||
5/31/2022 | 21 | Transfer IN | Adds | B | |||
5/31/2022 | 21 | Transfer Out | Exits | C | |||
5/31/2022 | 21 | Transfer IN | Adds | D | |||
5/31/2022 | 21 | Transfer Out | Exits | E | |||
5/31/2022 | 21 | Transfer IN | Adds | F |
Expected Output is :
Date | ID | Type | Type 2 | Division | Pillar | Cost Center | Company |
5/31/2022 | 21 | Transfer Out | Exits | X Division | A | C | E |
5/31/2022 | 21 | Transfer IN | Adds | Y Division | B | D | F |
Thanks,
Kuldeep
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
- Designer Cloud
- Expression
- Join
5 REPLIES 5
grazitti_sapna
17 - Castor
‎10-07-2022
03:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Kuldeepmathur , Here is the workflow. You can achieve it by using multi join. Please let me know if it was helpful.
Sapna Gupta
binuacs
21 - Polaris
‎10-07-2022
03:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-07-2022
03:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the quick revert I really appreciate your support.
I just added some more Ids in the data and it's actually breaking because of the date change
Input :
Date | ID | Type | Type 2 | Division | Pillar | Cost Center | Company |
5/31/2022 | 21 | Transfer Out | Exits | X Division | |||
5/31/2022 | 21 | Transfer IN | Adds | Y Division | |||
5/31/2022 | 21 | Transfer Out | Exits | A | |||
5/31/2022 | 21 | Transfer IN | Adds | B | |||
5/31/2022 | 21 | Transfer Out | Exits | C | |||
5/31/2022 | 21 | Transfer IN | Adds | D | |||
5/31/2022 | 21 | Transfer Out | Exits | E | |||
5/31/2022 | 21 | Transfer IN | Adds | F | |||
6/31/2022 | 22 | Transfer Out | Exits | G Division | |||
6/31/2022 | 22 | Transfer IN | Adds | H Division | |||
6/31/2022 | 22 | Transfer Out | Exits | M | |||
6/31/2022 | 22 | Transfer IN | Adds | N |
Output :
Thanks,
Kuldeep
Ben_H
11 - Bolide
‎10-07-2022
03:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Kuldeepmathur,
Here's an alternative method using transpose and crosstab that should work for you.
Regards,
Ben
‎10-09-2022
01:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Everybody for the support !
