Go to Qiita Advent Calendar 2024 Top
LoginSignup
2
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

@Floyed

LookerStudio：テキストに年度を足して日付フォーマットに変換

Last updated at Posted at 2024-03-20

LookerStudio テキストに年度を足して日付フォーマットに変換

CASE 
    WHEN LENGTH(日付テキスト) = 10 THEN SUBSTR(フィールド名, -6, 4)
    WHEN LENGTH(日付テキスト) = 9 THEN SUBSTR(フィールド名, -5, 3)
    WHEN LENGTH(日付テキスト) = 8 THEN SUBSTR(フィールド名, -4, 2)
    ElSE "Other"
END

EXTRACT(YEAR FROM 日付)

CONCAT( 2/日付から今年度を抽出 ,"/",1/不要なテキストを除外)

PARSE_DATE("%Y/%m/%d",3/今年度を日付テキストに足す)

IF (DATE_DIFF(日付　, 4/テキストを日付フォーマットに変換) = 0, "true", "false")

	WHEN REGEXP_CONTAINS(フィールド名, ",") = True THEN "Other"
2
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
2
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?