Forum Discussion
Table with Blank Rows
Hi 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!!
Hi 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
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!!
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
