問題描述

我有一個具有以下結構的csv文件，

i have csv file which having following structure.,

Alfreds,Centro,Ernst,Island,Bacchus
Germany,Mexico,Austria,UK,Canada
01,02,03,04,05

現在我必須將這些數據移動到數據庫中，如下所示.

Now i have to move that data into database like below.

Name,City,ID
Alfreds,Germay,01
Centro,Mexico,02
Ernst,Austria,03
Island,UK,04
Bacchus,Canda,05

我嘗試映射這些列，但我無法按列提取數據.

i try to map those colums but i can't able to extract the data in column wise.

這里我按列輸入數據，但我需要在 SQLServer 中按行插入數據

Here my input data in column wise but i need to insert those in row wise in SQLServer

任何人都可以建議在 sql server 中將列數據轉換為行數據的方法嗎?.

Can anyone suggest way to transfer column wise data into row wise in sql server?.

謝謝

推薦答案

@Andy,

在 NiFi 中也可以不使用 ExecuteScript.

It could be possible in NiFi also without using ExecuteScript.

我在 ExtractText 中提取了 3 個輸入行作為 input.1,input.2,input.3.然后使用 表達式語言 并將其存儲在 "TotalCount" 屬性中.

I have extract the 3 input rows as input.1,input.2,input.3 in ExtractText. And then count number of columns in "input.1" using AnydelinateValues in expression language and store that in "TotalCount" Attribute.

最初制作Count=1".

Initially made "Count=1".

使用循環概念通過使用Count"獲取第一列，然后在RouteOnAttribute中增加Count"檢查Count""le(totalcount)"

Using Loop Concept to get the first column by using "Count" and then increment "Count" Check "Count" in RouteOnAttribute "le(totalcount)"

現在使用 "Count" 屬性形成插入查詢.

Now form insert Query with "Count" Attribute.

它對我來說效果很好.它可能對某人有用.

It worked well for me.It could be useful for someone.

這篇關于如何在 NiFi 中映射流文件中的列數據?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！