Forum Discussion
Helper ITable with Blank Rows
Super UserHi Chipsahoy1
Can you tell us the logic behind the selected items for the blank rows? and can you share a sample result or how you want to use those data?
Appreciate your Kudos!!
Chipsahoy1Hi VahidDM . Thanks for your quick response. The result I would like to get is below. The reasoning is because these are the major/main items for that PO. So for PO 1, the main item is listed on PO line #2. For PO #2, the major item is on line 1 and for PO #3, the major item is on line 1.
The major items aren't always on PO line #s 1, 2, or 3. They could be on line #10, or 5. It all depends on who entered the info. So unfortunately the major item's PO line # is random.
PO PO Line# Modality Subtype Construct 1
1 Hip Revision Revision 1 2 Hip Total Advanced Hip 1 3 Hip Total Advanced Hip 2 1 Knee Partial Unicondylar Knee 2 2 Knee Other Upcharge 2 3 Knee Partial Unicondylar Knee 3 1 Shoulder Total Reverse Shoulder 3 2 Shoulder Total Reverse Shoulder 3 3 Shoulder Total Reverse Shoulder
I'm open to suggestions on how this can be achieved. Would creating a separate table to only show the major components be an option (like below table)?PO Modality Subtype Construct 1 Hip Total Advanced Hip
2 Knee Partial Unicondylar
3 Shoulder Total Reverse Shoulder
- VahidDM
Hi Chipsahoy1
How can we find which PO line is the main? do you have any table like key table to find that?
Appreciate your Kudos!!
- Chipsahoy1
VahidDM Unfortunately not, but there are keywords that I know are not the main components. for subtype and construct. The keywords like "revision" and "other" for subtype and "revision", and "upcharge" for construct. What makes this a bit trickier is, a revision can be a main component if there no other components are listed on that PO (see below).
PO # PO Line # Modality Subtype Construct 4
1 4 2 Knee Revision Revision So for the example above, I would need it to eventually show as this.
PO # PO Line # Modality Subtype Construct 4
1 Knee Revision Revision 4 2 Knee Revision Revision