03-20-2017 05:19 AM
I'm trying to use PowerBI with connection to an ElasticSearch database (with Hl7 messages).
I can already see the data, but some of those are only (as far as I can see) in the Raw_message and Message column.
I can split this column into several by indicating the carriage return as a separator and indicating the number of columns to create.
after this i got lines with :
OBX||ST|33000.5^QRS - INTERVAL(MSEC)^CPT9|3|78|MSEC
how can i disregard some lines ( for instance lines begin with 'MSH') ?
i can i work with this information ?
do you have any experience whit this ?