srinivasa1
Creator II
2016-11-11
02:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Guidance need to best way to desgin my data model
Hi All,
I have wired requirements to incorporate in my my data model and i have below requirements to achieve
Main Seller TransID | Order# | Sub Seller TransID |
XX1 | ABC01 | XX1 |
XX1 | ABC02 | XX1 |
XX1 | ABC03 | XX2 |
XX1 | ABC04 | XX2 |
XX1 | ABC05 | XX2 |
XX2 | ABC06 | XX1 |
XX2 | ABC07 | XX3 |
XX2 | ABC08 | XX3 |
If I select Main Seller TransID=XX1 Then I wanted to do
count of Order# belongs to Main Seller TransID(#XX1) + Sub Seller TransID(#XX1)(5+3=8) and Same way in case I select Main Seller TransID XX2(ie 3+3=6)
See here Main Seller TransID has 5 Order and it and also Main Seller TransID(XX1) found Sub Seller TransID that’s (XX1 ) and it has 3 Order in that case wanted desgin my data model such way when I select Main Seller TransID(XX1) I need add order of Main Seller TransID(XX1)5 +3 Sub Seller TransID that’s (XX1 ) |
Attached Sample app and details for same.
Thanks in advance for any help on achieve this best way
- Tags:
- data modelling
742 Views
2 Replies
settu_periasamy
Master III
2016-11-11
12:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create on Variable like
v1 : =Concat(DISTINCT chr(39)&[Main Seller TransID]&chr(39),',')
In the text box try the below expression
=Count(Order#) + Count({1<[Sub Seller TransID]={$(v1)}>}Order#)
srinivasa1
Creator II
2016-11-11
01:48 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Settu,
Do you have any idea how I can achieve this in ETL script?
Thx
633 Views