Icon

JKISeason3-8_​tofusa

Level: Medium

Description: You are reorganizing a data warehouse in your company, working with a filesystem that creates parent folders if you give it a reference for a child folder. For example, if you ask the filesystem to create “folder1/folder2” and neither folder1 or folder2 exist, it will create both, with folder2 inside folder1, without raising an error. Given a list of folders, you want to keep only the longest unique child folders, filtering out references to parent folders that will be generated anyway for efficiency.

Here's an example of an initial list of folders:

- folder1/folder3
- folder1/folder3/folder22
- folder1/folder3/folder22/folder47

After executing your workflow, the list above should only contain a reference for folder1/folder3/folder22/folder47.

Level: MediumDescription: You are reorganizing a data warehouse in your company, working with a filesystem that creates parent folders if you give it areference for a child folder. For example, if you ask the filesystem to create “folder1/folder2” and neither folder1 or folder2 exist, it will createboth, with folder2 inside folder1, without raising an error. Given a list of folders, you want to keep only the longest unique child folders, filteringout references to parent folders that will be generated anyway for efficiency.Here's an example of an initial list of folders:- folder1/folder3- folder1/folder3/folder22- folder1/folder3/folder22/folder47After executing your workflow, the list above should only contain a reference for folder1/folder3/folder22/folder47.説明 子フォルダの参照を与えると親フォルダを作成するファイルシステムを使用して、社内のデータウェアハウスを再編成しています。例えば、「folder1/folder2」を作成するようにファイルシステムに要求し、folder1もfolder2も存在しない場合、ファイルシステムはエラーを発生させることなく、folder1の中にfolder2を作成します。フォルダーのリストが与えられた場合、効率化のために、いずれにせよ生成される親フォルダーへの参照をフィルタリングして、最も長いユニークな子フォルダーのみを保持したい。フォルダーの初期リストの例を以下に示す:- folder1/folder3- folder1/folder3/folder22- folder1/folder3/folder22/folder47ワークフローを実行した後、上記のリストにはfolder1/folder3/folder22/folder47の参照だけが含まれているはずです。 Node 2506parentexclude parent folder Table Reader String Manipulation ReferenceRow Filter Level: MediumDescription: You are reorganizing a data warehouse in your company, working with a filesystem that creates parent folders if you give it areference for a child folder. For example, if you ask the filesystem to create “folder1/folder2” and neither folder1 or folder2 exist, it will createboth, with folder2 inside folder1, without raising an error. Given a list of folders, you want to keep only the longest unique child folders, filteringout references to parent folders that will be generated anyway for efficiency.Here's an example of an initial list of folders:- folder1/folder3- folder1/folder3/folder22- folder1/folder3/folder22/folder47After executing your workflow, the list above should only contain a reference for folder1/folder3/folder22/folder47.説明 子フォルダの参照を与えると親フォルダを作成するファイルシステムを使用して、社内のデータウェアハウスを再編成しています。例えば、「folder1/folder2」を作成するようにファイルシステムに要求し、folder1もfolder2も存在しない場合、ファイルシステムはエラーを発生させることなく、folder1の中にfolder2を作成します。フォルダーのリストが与えられた場合、効率化のために、いずれにせよ生成される親フォルダーへの参照をフィルタリングして、最も長いユニークな子フォルダーのみを保持したい。フォルダーの初期リストの例を以下に示す:- folder1/folder3- folder1/folder3/folder22- folder1/folder3/folder22/folder47ワークフローを実行した後、上記のリストにはfolder1/folder3/folder22/folder47の参照だけが含まれているはずです。 Node 2506parentexclude parent folder Table Reader String Manipulation ReferenceRow Filter

Nodes

Extensions

Links