You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
I need to find a way to parse a csv file with metrics values based off of 2 headers.
Example:
csv file
TimeStamp,KeyLabel,SubKeyLabel,Metrics 1,Metrics 2,3 Metrics
1234567890,ABC,404 Not Found, 22,11,123
1234567890,ABC,ALL Good,33,12,321
1234567890,DEF,404 Not Found,44,18,456
1234567890,DEF,ALL Good,27,17,654
Results should be:
KeyLabel-"ABC",SubKeyLabel="404 Not Found", "Metrics 1 Value": "22"
KevLabel="ABC"
SubKeyLabel="404 Not Found'
"Metrics 2 Value": "11"
KeyLabel-"ABC", SubKeyLabel="404 Not Found"
1, "3
Metrics Value": 123"
KeyLabel-"ABC" ,SubKeyLabel-"ALL Good", "Metrics 1 Value™: 33" KeyLabel-"ABC", SubKeyLabel="ALL Good", "Metrics 2 Value": "12"
KeyLabel="ABC", SubKeyLabel-"ALL Good"
"3 Metrics Value": "321
KeyLabel-"DEF", SubKeyLabel="404 Not Found"
"Metrics
1 Value"« "дд
KeyLabel="DEF", SubKeyLabel="404 Not Found"
'Metrics 2 Value". 18
KeyLabel-"DEF", SubKeyLabel-"404 Not Found", "3 Metrics Value*: "456"
KeyLabel-"DEF", SubKeyLabel-"ALL Good"
"Metrics 1 Value": "27"
KeyLabel-"DEF',SubKeyLabel-"ALL Good", "Metrics 2 Value': 17" KeyLabel-"DEF", SubKeyLabel-"ALL Good", "3 Metrics Value: "654*
Beta Was this translation helpful? Give feedback.
All reactions